<?php
//======================================================================================
//
// Function: Maintain HUB_WEBCNT
//
// Programmer: JKJ
// Date : 2024-12-02
//
// Copyright Reeft A/S (c) - 2024
//======================================================================================
//======================================================================================
// Get input
//======================================================================================
if (isset($_REQUEST["HUB_SERTYP"])) {
$HUB_SERTYP = $_REQUEST["HUB_SERTYP"];
} else {
$HUB_SERTYP = '';
}
//======================================================================================
// Make line uppercase
//======================================================================================
//======================================================================================
// General config
//======================================================================================
include "config/config.php";
//======================================================================================
// Check if user is logged in?
//======================================================================================
include "login_check.php";
//======================================================================================
// Get session variables
//======================================================================================
include "include/getsession.php";
// include "include/uuid_create.php";
// include "include/generate_password_md5.php";
//======================================================================================
// Set language
//======================================================================================
include "include/set_language.php";
//======================================================================================
// Set defaults
//======================================================================================
// $pk_reference = $_SESSION['session_dft_pk_reference'];
// $referenceCode = $_SESSION['session_dft_referencecode'];
// $referenceName = $_SESSION['session_dft_referencename'];
//======================================================================================
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title><?php echo $datahub_text0001 ?></title>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="REEFTvisual - Stoptime">
<meta name="author" content="REEFT A/S">
<link rel="icon" href="images/favicon/favicon.ico">
<!-- Bootstrap / jQuery -->
<link href="css/bootstrap4.3.1/css/bootstrap.custom.min.css" rel="stylesheet">
<link href="css/bootstrap4.3.1/css/themes/bootstrap.custom.min.css" rel="stylesheet">
<link href="css/bootstrap4.3.1/css/normalize.css" rel="stylesheet" type="text/css">
<link href="css/sticky-footer.css" rel="stylesheet" type="text/css">
<!-- Custom styles for this template -->
<link href="css/custom.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<script src="css/fontawesome6.5.1/js/all.min.js"></script>
<script src="css/fontawesome6.5.1/js/sharp-light.min.js"></script>
<script src="css/fontawesome6.5.1/js/sharp-regular.min.js"></script>
<script src="css/fontawesome6.5.1/js/sharp-solid.min.js"></script>
<script src="css/fontawesome6.5.1/js/sharp-thin.min.js"></script>
<link href="css/bootstrap_animation/css/animate4/animate.css" rel="stylesheet" type="text/css">
<!--<link href="javascript/chosen/chosen.css" rel="stylesheet" type="text/css">-->
<link href="javascript/jquery-ui/jquery-ui.min.css" rel="stylesheet" type="text/css"/>
<script src="javascript/jquery.js"></script>
<script src="css/bootstrap4.3.1/js/popper.js"></script>
<script src="css/bootstrap4.3.1/js/bootstrap.min.js"></script>
<script src="javascript/jquery-ui/jquery-ui.min.js"></script>
<script src="javascript/jquery.ui.touch-punch.min.js"></script>
<link href="javascript/bgrins-spectrum/spectrum.css" rel="stylesheet" type="text/css">
<script src="javascript/bgrins-spectrum/spectrum.js"></script>
<script src="javascript/moment.min.js"></script>
<script src="javascript/moment-with-locales.min.js"></script>
<script src="javascript/moment-duration-format.min.js"></script>
<script src="javascript/number_format/jquery.number.min.js"></script>
<script src="javascript/jquery.scrollTo.min.js"></script>
<!-- Data tables start -->
<link href="javascript/datatables.3.12/datatables.min.css" rel="stylesheet">
<script src="javascript/datatables.3.12/datatables.min.js"></script>
<!-- Data tables end -->
<script src="javascript/chosen/chosen.jquery.min.js" type="text/javascript"></script>
<script src="javascript/viewer-master/dist/viewer.min.js"></script>
<link href="javascript/viewer-master/dist/viewer.min.css" rel="stylesheet">
<script src="javascript/ajaxq/ajaxq.js"></script>
<link id="scrollUpTheme" rel="stylesheet" href="javascript/scrollup-master/dist/css/themes/image.css">
<script src="javascript/scrollup-master/dist/jquery.scrollUp.js"></script>
<script src="javascript/shortcut.js"></script>
<script src="javascript/_reeft_js/set_font_awesome_icon_type.js"></script>
<script src="javascript/_reeft_js/date_convert.js"></script>
<style>
.btn-custom-wide {
height:60px;
width:210px;
}
.text-truncate-dt {
max-width: 450px;
white-space: nowrap;
overflow: hidden;
text-overflow: ellipsis;
}
.text-align-center-dt {
text-align: center;
}
.text-align-left-dt {
text-align: left;
}
.text-align-right-dt {
text-align: right;
}
.modal-xxl {
max-width: 80%;
}
.modal-xl {
max-width: 50%;
}
.border-3 {
border-width:3px !important;
}
td .hover-img {
position:relative;
}
td .hover-img span {
position:absolute; left:-9999px; top:-9999px; z-index:9999;
}
td:hover .hover-img span {
top: 5px;
left:0px;
}
.chosen-container-single {
min-width: 100%;
}
</style>
<script language="JavaScript">
//=============================================================================
// Globals
//=============================================================================
var thisCurrentRow;
var thisGlobalRowData;
var thisGlobalTableData;
var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A = 'Text/Char';
var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N = 'Number/Value';
var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L = 'Date (ISO)';
var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T = 'Time (ISO)';
// Save field
var save_HUB_WEBNAM = '';
var save_HUB_SERTYP = '';
var global_debug = 'N';
// Add allowed Y/N
var GLOBAL_ADD_ALLOWED = 'N';
// Show group buttons
var GLOBAL_SHOW_GROUP_BUTTONS = 'Y';
// Delete allowed Y/N
var GLOBAL_DELETE_ALLOWED = 'N';
// sortMode
var GLOBAL_SORTMODE = 'DESC';
var jsonDataSave = {};
var DFT_DATE_DISPLAY_FORMAT = '<?php //echo $DFT_DATE_DISPLAY_FORMAT ?>';
var DFT_LANGUAGE = '<?php //echo $DFT_LANGUAGE ?>';
var GLOBAL_TOTALPAGESSTOPVALUE = 10;
// Save field
//var save_CFGNAM = '';
$(function () {
$.scrollUp({
scrollName: 'scrollUp', // Element ID
//topDistance: '1800', // Distance from top before showing element (px)
//topSpeed: 300, // Speed back to top (ms)
scrollDistance: '300', // Distance from top before showing element (px)
scrollSpeed: 300, // Speed back to top (ms)
animation: 'fade', // Fade, slide, none
animationInSpeed: 200, // Animation in speed (ms)
animationOutSpeed: 200, // Animation out speed (ms)
scrollText: false, //'Scroll to top', // Text for element
activeOverlay: false, // Set CSS color to display scrollUp active point, e.g '#00FFFF'
});
});
//=============================================================================
// Get data
//=============================================================================
function getData( inputGetData )
{
// Reset, show all
if ( inputGetData == '*RESET' ) {
inputGetData = '';
//Clear search
thisGlobalTableData.search( '' );
}
//Only initialize datatables once, else just draw it
if ( $.fn.dataTable.isDataTable( '#REEFTvisual_data' ) ) {
console.log('1');
thisGlobalTableData.draw(); // fire in the hole
}
else {
console.log('2');
setDataTables();
}
}
//=============================================================================
// Set datatables
//=============================================================================
function setDataTables()
{
// Delete allowed?
if ( GLOBAL_DELETE_ALLOWED == 'Y' ) {
var show_the_delete_button = true;
} else {
var show_the_delete_button = false;
}
parmData = '';
new $('#REEFTvisual_data').DataTable({
"ajax": {
"url": 'hub_webcnt_maintain_get.php',
"type": "POST",
"data": function (parmData) {
// Add custom parameters to the ajax call
var input_HUB_SERTYP = $('#input-HUB_SERTYP').val();
parmData.HUB_SERTYP = input_HUB_SERTYP;
parmData.callType = '*DATA';
parmData.orderBy = '1';
},
dataSrc: function (jsonData) { //return data
var rpyCMPNO = jsonData.header.rpyCMPNO;
var rpyCMPNO_Name = jsonData.header.rpyCMPNO_Name;
var rpyFile_name = jsonData.header.rpyFile_name
var rpyFile_description = jsonData.header.rpyFile_description
var rpyTableRecordsFound = jsonData.header.rpyTableRecordsFound
var returnCode = jsonData.header.returnCode;
var returnMsg = jsonData.header.returnMsg;
var entries_found = jsonData.header.entries_found;
var response_sec = jsonData.header.response_sec;
// Show load time
$('#text-total-records-found').html( rpyTableRecordsFound );
$('#load-time-from-database').html('entries found: ' + entries_found + ' (' + response_sec + ')');
// Set Company and file information
if ( rpyFile_name != '' ) {
$('#data-hub-company-information').html( '<span title="' + rpyFile_name + ' - ' + rpyFile_description + '">' + rpyCMPNO_Name + ' (' + rpyCMPNO + ')' + '</span>' ).css('font-size','1.3em');
}
// Init button line fields
var HTMLlineButtons = '';
var HTMLlineButtonsModal = '';
var selectedButtonClass = 'btn-dark';
//=====================================================================================
// Create group buttons, only if wanted
//=====================================================================================
if ( GLOBAL_SHOW_GROUP_BUTTONS == 'Y' ) {
$.each( jsonData.header_buttons, function( index, object ){
var buttonLine = object.buttonLine;
var buttonCount = object.buttonCount;
// if ( input_HUB_WEBNAM == buttonLine ) {
// selectedButtonClass = 'btn-success';
// } else {
// selectedButtonClass = 'btn-dark';
// }
selectedButtonClass = 'btn-dark';
var selectButtonLineID = 'select-button-line-id-' + buttonLine;
var selectButtonLineIDmodal = 'select-button-line-id-modal-' + buttonLine + '_' + buttonCount;
HTMLlineButtons += '<button type="button" onclick="setWebserviceSearch(\'' + buttonLine + '\')" style="cursor:default" id="' + selectButtonLineID + '" class="btn ' + selectedButtonClass + ' select-button-line btn-sm mr-1 mb-1">'
+ buttonLine + ' (<b>' + buttonCount + '</b>)'
+ '</button>'
HTMLlineButtonsModal += '<button type="button" onclick="selectGroupValueModal(\'' + buttonLine + '\')" style="width:100px" id="' + selectButtonLineIDmodal + '" class="select-button-line-modal btn btn-primary btn-sm mr-1 mb-1">'
+ buttonLine
+ '</button>'
});
// Reset
HTMLlineButtons += '<button type="button" onclick="setWebserviceSearch(\'' + '' + '\')" style="cursor:default" id="' + 'RESET' + '" class="btn ' + 'btn-warning' + ' select-button-line btn-sm mr-1 mb-1">'
+ '<b>' + 'RESET' + '</b>'
+ '</button>'
$('#data-result-button-group').html(HTMLlineButtons);
$('#data-result-button-group-modal').html(HTMLlineButtonsModal);
}
//=====================================================================================
return jsonData.data;
}
},
searching: true,
processing: true,
serverSide: true,
responsive: true,
fixedHeader: true,
order: [[ 0, "asc" ]],
columns:
[
{ data: "HUB_WEBNAM" }, // 0
{ data: "HUB_LSTCAL" }, // 1
{ data: "HUB_DESCP_FULL" }, // 2
{ data: "HUB_COUNT" }, // 3
{ data: "HUB_SERTYP" }, // 4
{
// 5
// Since we are combining multiple data fields, use null as the data source
data: null,
render: function (data, type, row, meta)
{
// Create report button
var HUB_CHRCOL = row.HUB_CHRCOL;
var HUB_CHRCOL_TEXT = '';
HUB_CHRCOL_TEXT = '<div style="display:block;margin:auto;width:25px;height:25px; background-color:' + HUB_CHRCOL + '"> </div>';
return HUB_CHRCOL_TEXT;
}
},
{ data: "HUB_CHRTXT" }, // 6
{ data: "HUB_CHRMIN" }, // 7
{ data: "HUB_CHRMAX" }, // 8
{
// 9
// Since we are combining multiple data fields, use null as the data source
data: null,
render: function (data, type, row, meta)
{
if ( row.HUB_SHWCHT == 'N' ) {
HUB_SHWCHT_text = '<?php echo $datahub_NO ?>';
} else {
HUB_SHWCHT_text = '<?php echo $datahub_YES ?>';
}
// Create edit button
return HUB_SHWCHT_text;
}
},
{
// 10
// Since we are combining multiple data fields, use null as the data source
data: null,
render: function (data, type, row, meta)
{
// Create edit button
var myButton = '<button id="edt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="edit-btn btn btn-primary btn-block text-truncate xmr-1"><?php echo $datahub_button_edit_no_icon ?></button>';
return myButton;
}
},
{
// 11
// Since we are combining multiple data fields, use null as the data source
data: null,
render: function (data, type, row, meta)
{
// Create delete button
var myButton = '<button id="dlt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="delete-btn btn btn-danger text-truncate btn-block xmr-1"><?php echo $datahub_button_delete ?></button>';
return myButton;
}
},
{
// 12
// Since we are combining multiple data fields, use null as the data source
data: null,
render: function (data, type, row, meta)
{
// Create delete button
var myButton = '<button id="dlt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="show-trans-btn btn btn-primary text-truncate btn-block xmr-1"><?php echo $datahub_button_transactions_no_icon ?></button>';
return myButton;
}
},
{
// 13
// Since we are combining multiple data fields, use null as the data source
data: null,
render: function (data, type, row, meta)
{
// Create delete button
var myButton = '<button id="dlt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="show-chart-trans-btn btn btn-primary btn-block text-truncate xmr-1"><?php echo $datahub_button_chart_no_icon ?></button>';
return myButton;
}
},
{ data: "HUB_DBGVAL" }, // 14
{ data: "HUB_DESCP1" }, // 15
{ data: "HUB_DESCP2" }, // 16
{ data: "HUB_CHRCOL" }, // 17
{ data: "HUB_SHWCHT" } // 18
],
columnDefs: [
// Make sure that buttons are not "hided" when responsive kicks in
{ responsivePriority: 10, targets: 8 },
{ responsivePriority: 20, targets: 7 },
{ responsivePriority: 30, targets: 6 },
{ responsivePriority: 40, targets: 5 },
{ responsivePriority: 50, targets: 4 },
{ responsivePriority: 60, targets: 3 },
// Make sure the sorts toggle asc/desc and not asc/desc/no-sort
//{ orderSequence: ['asc', 'desc'], targets: [3] },
{ orderSequence: ['asc', 'desc'], targets: ['_all'] },
{
"targets": [ 11 ],
"visible": show_the_delete_button,
"searchable": false,
"orderable": false
},
{
"targets": [ 2,3 ],
"max-width": '120px',
"className": "text-truncate-dt" //class to mimic text-truncate in dt
},
{
"targets": [ 5,10,12,13 ],
"visible": true,
"searchable": false,
"orderable": false
},
{
"targets": [ 14,15,16,17,18 ],
"visible": false,
"searchable": false,
"orderable": false
},
{
"targets": [ 3,4,9 ],
"className": "text-align-center-dt"
},
],
pageLength: 10,
lengthChange: true,
layout: {
top1Start: [{
pageLength: {
menu: [10, 25, 50, 100]
}
}],
top1End: [{
search: {
placeholder: '<?php echo $datahub_datatable_Search_text ?>',
processing: true
}
}],
topStart: {
info:{
}
},
topEnd: {
paging: {
buttons: 7,
firstLast: true,
boundaryNumbers: true,
}
},
bottomStart: {
buttons: [
{
extend: 'copyHtml5',
text: '<img src="images/copy.png" height="25"> Copy to Clipboard',
titleAttr: 'Copy',
title: 'DATAHUB - Webservice Data Export - Copy to clipboard',
exportOptions: {
// Fields to export (https://datatables.net/reference/button/csv#Examples)
columns: [0,1,2,3,4,5]
}
},
{
extend: 'excelHtml5',
text: '<img src="images/microsoft_excel_logo.png" height="25"> Excel',
titleAttr: 'Excel',
title: function(){
return 'DATAHUB - Webservice Data Export';
},
filename: function(){
var p_id = moment().format('YYYY-MM-DD HH.mm.ss');
return 'DATAHUB - Webservice Data Export - ' + p_id;
},
exportOptions: {
// Fields to export (https://datatables.net/reference/button/csv#Examples)
columns: [0,1,2,3,4,5]
}
},
{
extend: 'pdfHtml5',
text: '<img src="images/pdf_logo.png" height="25"> PDF',
titleAttr: 'PDF',
orientation: 'landscape',
title: 'DATAHUB - Webservice Data Export - PDF',
filename: function(){
var p_id = moment().format('YYYY-MM-DD HH.mm.ss');
return 'DATAHUB - Webservice Data Export - PDF - ' + p_id;
},
exportOptions: {
// Fields to export (https://datatables.net/reference/button/csv#Examples)
columns: [0,1,2,3,4,5],
modifier: {
page: 'all'
}
}
}
]
},
bottomEnd: {
paging: {
buttons: 7,
firstLast: true,
boundaryNumbers: true
}
}
},
language:
{
"decimal": ",",
"thousands": ".",
"emptyTable": "<?php echo $datahub_datatable_emptyTable ?>",
"info": "<?php echo $datahub_datatable_Info ?>",
"infoEmpty": "<?php echo $datahub_datatable_InfoEmpty ?>",
"InfoFiltered": "<?php echo $datahub_datatable_InfoFiltered ?>",
"infoPostFix": "",
"lengthMenu": "<?php echo $datahub_datatable_LengthMenu ?>",
"loadingRecords": "",
"processing": "<?php echo $datahub_datatable_Processing ?>",
"search": "<?php echo $datahub_datatable_Search ?>",
"zeroRecords": "<?php echo $datahub_datatable_ZeroRecords ?>",
"paginate":
{
"first": "<?php echo $datahub_datatable_First ?>",
"last": "<?php echo $datahub_datatable_Last ?>",
"next": "<?php echo $datahub_datatable_Next ?>",
"previous": "<?php echo $datahub_datatable_Previous ?>"
},
"aria": {
"orderable": "Order by this column",
"orderableReverse": "Reverse order this column"
}
},
"rowCallback": function(row, data, index)
{
},
"preDrawCallback": function(settings)
{
},
"initComplete": function ()
{
}
});
//=============================================================================
// Setup the data to be able to update the table without reloading from the server
//=============================================================================
// Save the table in a global variable
thisGlobalTableData = $('#REEFTvisual_data').DataTable();
// Handle click on "Edit" button
$('#REEFTvisual_data tbody').on('click', '.edit-btn', function() {
thisCurrentRow = $(this).closest('tr');
thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();
// Debug
// console.log("edit");
// console.log(thisGlobalRowData);
//console.log(thisCurrentRow);
dataChange();
});
// Handle click on "Delete" button
$('#REEFTvisual_data tbody').on('click', '.delete-btn', function() {
thisCurrentRow = $(this).closest('tr');
thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();
// Debug
// console.log(thisGlobalRowData);
// console.log(thisCurrentRow);
dataDeleteConfirm();
});
// Handle click on "Show transactions" button
$('#REEFTvisual_data tbody').on('click', '.show-trans-btn', function() {
thisCurrentRow = $(this).closest('tr');
thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();
showTranscations( thisGlobalRowData.HUB_WEBNAM );
});
// Handle click on "Show char transactions" button
$('#REEFTvisual_data tbody').on('click', '.show-chart-trans-btn', function() {
thisCurrentRow = $(this).closest('tr');
thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();
showChartTransactions( thisGlobalRowData.HUB_WEBNAM );
});
//=============================================================================
//=============================================================================
// Place curor in search field - the wrapper id is provided by datatables - debug it!
//=============================================================================
$('#REEFTvisual_data_wrapper div.dt-search .dt-input').focus();
//=============================================================================
}
//=============================================================================
// Reason addd -- not used
//=============================================================================
function dataAdd ( input_pk_type )
{
var myHUB_WEBNAM = $('#input-HUB_SERTYP').val();
resetModalInputFields();
setModalInputDefaultFields();
$('#input-mode').val('*add');
// Reset save field
save_HUB_WEBNAM = '';
save_HUB_SERTYP = '';
// Show on chart (default to Y)
if ( HUB_SHWCHT.trim() == '' ) {
set_YES_NO_Button('Y','HUB_SHWCHT','value')
}
// Set HUB_LSTCAL - default YES
$('#button-deleted-yes').removeClass('btn-primary').addClass('btn-success');
$('#button-deleted-no').removeClass('btn-success').addClass('btn-primary');
// Reset modal message
resetModalMessage();
// Remove key fields readonly
$('#modal-input-HUB_WEBNAM').removeAttr('readonly','readonly');
$('#data-result-button-group-modal').removeClass('d-none');
// Show modal
$('#hub_webcnt_maintainModal').modal('show');
$('#hub_webcnt_maintainModal').on('shown.bs.modal', function () {
$('#modal-input-HUB_WEBNAM').trigger('focus');
})
}
//=============================================================================
// Show details
//=============================================================================
function dataChange( )
{
var row = thisGlobalRowData;
// Save in fields
var HUB_WEBNAM = row["HUB_WEBNAM"];
var HUB_LSTCAL = row["HUB_LSTCAL"];
var HUB_DESCP1 = row["HUB_DESCP1"];
var HUB_DESCP2 = row["HUB_DESCP2"];
var HUB_COUNT = row["HUB_COUNT"];
var HUB_SERTYP = row["HUB_SERTYP"];
var HUB_CHRCOL = row["HUB_CHRCOL"];
var HUB_CHRTXT = row["HUB_CHRTXT"];
var HUB_CHRMIN = row["HUB_CHRMIN"];
var HUB_CHRMAX = row["HUB_CHRMAX"];
var HUB_DBGVAL = row["HUB_DBGVAL"];
var HUB_SHWCHT = row["HUB_SHWCHT"];
var counter = row["counter"];
$('#input-mode').val('*update');
save_HUB_WEBNAM = HUB_WEBNAM;
// Move to input fields
$('#modal-input-counter').val(counter);
$('#modal-input-HUB_WEBNAM').val( HUB_WEBNAM );
$('#modal-input-HUB_LSTCAL').val( HUB_LSTCAL );
$('#modal-input-HUB_DESCP1').val( HUB_DESCP1 );
$('#modal-input-HUB_DESCP2').val( HUB_DESCP2 );
$('#modal-input-HUB_SERTYP').val( HUB_SERTYP );
$('#modal-input-HUB_COUNT').val( HUB_COUNT );
$('#modal-input-HUB_CHRTXT').val( HUB_CHRTXT );
$('#modal-input-HUB_CHRMIN').val( HUB_CHRMIN );
$('#modal-input-HUB_CHRMAX').val( HUB_CHRMAX );
$('#modal-input-HUB_DBGVAL').val( HUB_DBGVAL );
$('#modal-input-HUB_SHWCHT').val( HUB_SHWCHT );
// Make key fields readonly
$('#modal-input-HUB_WEBNAM').attr('readonly','readonly');
$('#data-result-button-group-modal').removeClass('d-none');
// Set show on chart (default to Y)
if ( HUB_SHWCHT.trim() == '' ) {
set_YES_NO_Button('Y','HUB_SHWCHT','value')
} else {
set_YES_NO_Button(HUB_SHWCHT,'HUB_SHWCHT','value')
}
// Set color
if ( HUB_CHRCOL == '' ) {
HUB_CHRCOL = '#0000ff'
}
if ( HUB_CHRCOL == '#000000' ) {
HUB_CHRCOL = '#0000ff'
}
//alert(HUB_CHRCOL)
$('#modal-input-HUB_CHRCOL').spectrum("set", '#' + HUB_CHRCOL );
$('.read-only-class').attr('readonly','readonly');
// Reset modal message
resetModalMessage();
// Show modal
$('#hub_webcnt_maintainModal').modal('show');
$('#hub_webcnt_maintainModal').on('shown.bs.modal', function () {
$('#modal-input-HUB_SERTYP').trigger('focus');
})
}
//=============================================================================
// Save
//=============================================================================
function dataSave()
{
// Reset modal message
resetModalMessage();
// Check content of fields
if ( $('#modal-input-HUB_WEBNAM').val() == '' ) {
$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0082 ?>' );
$('#modal-save-button').addClass('disabled').prop("disabled", true);
$('#modal-input-HUB_WEBNAM').trigger('focus');
return false;
}
// if ( $('#modal-input-HUB_DESCP2').val() == '' ) {
// $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0085 ?>' );
// $('#modal-save-button').addClass('disabled').prop("disabled", true);
// $('#modal-input-HUB_DESCP2').trigger('focus');
// return false;
// }
if ( $('#modal-input-HUB_DESCP1').val() == '' ) {
$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0084 ?>' );
$('#modal-save-button').addClass('disabled').prop("disabled", true);
$('#modal-input-HUB_DESCP1').trigger('focus');
return false;
}
if ( $('#modal-input-HUB_SERTYP').val() == '' ) {
$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0086 ?>' );
$('#modal-save-button').addClass('disabled').prop("disabled", true);
$('#modal-input-HUB_SERTYP').trigger('focus');
return false;
}
// if ( $('#modal-input-HUB_COUNT').val() == '' ) {
// $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0083 ?>' );
// $('#modal-save-button').addClass('disabled').prop("disabled", true);
// $('#modal-input-HUB_COUNT').trigger('focus');
// return false;
// }
var mode = $('#input-mode').val();
//===============================================================================
// Remove # if any
//===============================================================================
// Setup remove string
let mySaveString;
// var myWorkField = $('#modal-input-DESCP1').val();
// myWorkField = myWorkField.replace("#", "");
// $('#modal-input-DESCP1').val( myWorkField );
// var myWorkField = $('#modal-input-DESCP2').val();
// myWorkField = myWorkField.replace("#", "");
// $('#modal-input-DESCP2').val( myWorkField );
var myWorkField = $('#modal-input-HUB_CHRMIN').val();
myWorkField = myWorkField.replace(",", ".");
myWorkField = parseFloat(myWorkField).toFixed(3).toString();
$('#modal-input-CHRMIN').val( myWorkField );
var myWorkField = $('#modal-input-HUB_CHRMAX').val();
myWorkField = myWorkField.replace(",", ".");
myWorkField = parseFloat(myWorkField).toFixed(3).toString();
$('#modal-input-CHRMAX').val( myWorkField );
var myWorkField = $('#modal-input-HUB_DBGVAL').val();
myWorkField = myWorkField.replace(",", ".");
myWorkField = parseFloat(myWorkField).toFixed(0).toString();
$('#modal-input-DBGVAL').val( myWorkField );
//===============================================================================
// Make sure key does not have space and are in uppercase
// var myWorkField = $('#modal-input-HUB_WEBNAM').val();
// myWorkField = myWorkField.replace(" ", "_");
// myWorkField = myWorkField.toUpperCase();
// $('#modal-input-HUB_WEBNAM').val( myWorkField );
// Make array and json
var myData = $('#dataForm').find('input, select, textarea').serializeArray();
var result = JSON.stringify(myData);
var result = encodeURIComponent( result );
// console.log(result);
// console.log(myData);
// return;
var parmData = 'data=' + result
+ '&mode=' + mode
;
$.ajax({
url: "hub_webcnt_maintain_save.php",
type: "POST",
data: parmData,
dataType: "json",
cache: false,
})
.done(function( jsonData ) {
//=================================================================
// START - Update the table without doing a server reload
// Only update
//=================================================================
if ( mode == '*update' ) {
event.preventDefault();
// Debug
// console.log(myGlobalRowData[0]);
// console.log(myGlobalRowData[1]);
// console.log(myGlobalRowData[2]);
// console.log(myCurrentRow);
// console.table(myGlobalTableData);
// Get the data for the "Change/Delete button", so we do not need to create it again
// myChangeButtonData = myGlobalRowData[6];
// myDeleteButtonData = myGlobalRowData[7];
//==============================================
// Use this if you want to update the whole row
//==============================================
// myGlobalTableData.row(myCurrentRow).data([
// modal_input_HUB_WEBNAM,
// modal_input_LSTCAL,
// modal_input_DESCP1,
// modal_input_DESCP2,
// modal_input_COUNT,
// modal_input_SERTYP,
// myChangeButtonData,
// myDeleteButtonData,
// modal_input_DESCP1,
// modal_input_DESCP2
// ])
// .draw(false)
// ;
//=======================================================
// Use this if you want to update one or more table cells
//=======================================================
thisGlobalTableData.cell(thisCurrentRow, 0 ).data( $('#modal-input-HUB_WEBNAM').val() );
thisGlobalTableData.cell(thisCurrentRow, 1 ).data( $('#modal-input-HUB_LSTCAL').val() );
thisGlobalTableData.cell(thisCurrentRow, 2 ).data( $('#modal-input-HUB_DESCP1').val() + '<br>' + $('#modal-input-HUB_DESCP2').val() );
thisGlobalTableData.cell(thisCurrentRow, 3 ).data( $('#modal-input-HUB_COUNT').val() );
thisGlobalTableData.cell(thisCurrentRow, 4 ).data( $('#modal-input-HUB_SERTYP').val() );
thisGlobalTableData.cell(thisCurrentRow, 6 ).data( $('#modal-input-HUB_CHRTXT').val() );
thisGlobalTableData.cell(thisCurrentRow, 7 ).data( $('#modal-input-HUB_CHRMIN').val() );
thisGlobalTableData.cell(thisCurrentRow, 8 ).data( $('#modal-input-HUB_CHRMAX').val() );
// 9 = Show on chart Y/N
// 10 = Edit button
// 11 = Delete button
// 12 = Transactions
// 13 = Chart
thisGlobalTableData.cell(thisCurrentRow, 14 ).data( $('#modal-input-HUB_DBGVAL').val() );
thisGlobalTableData.cell(thisCurrentRow, 15 ).data( $('#modal-input-HUB_DESCP1').val() );
thisGlobalTableData.cell(thisCurrentRow, 16 ).data( $('#modal-input-HUB_DESCP2').val() );
thisGlobalTableData.cell(thisCurrentRow, 17 ).data( $('#modal-input-HUB_CHRCOL').val() );
thisGlobalTableData.cell(thisCurrentRow, 18 ).data( $('#modal-input-HUB_SHWCHT').val() );
//.draw(false);
// Show new color
var HUB_CHRCOL_TEXT = '<div style="display:block;margin:auto;width:25px;height:25px; background-color:' + $('#modal-input-HUB_CHRCOL').val() + '"> </div>';
thisGlobalTableData.cell(thisCurrentRow, 5 ).data( HUB_CHRCOL_TEXT );
//thisGlobalTableData.cell(thisCurrentRow, 5 ).data( HUB_CHRCOL_TEXT ).draw(false);
if ( $('#modal-input-HUB_SHWCHT').val() == 'N' ) {
HUB_SHWCHT_text = '<?php echo $datahub_NO ?>';
} else {
HUB_SHWCHT_text = '<?php echo $datahub_YES ?>';
}
thisGlobalTableData.cell(thisCurrentRow, 9 ).data( HUB_SHWCHT_text );
}
//=================================================================
// END - Update the table without doing a server reload
//=================================================================
//=================================================================
// Close the modal
//=================================================================
$('#hub_webcnt_maintainModal').modal('hide');
//=================================================================
// Only when add
//=================================================================
if ( mode == '*add' ) {
var myButtonID = 'select-button-line-id-' + $('#input-HUB_SERTYP').val();
$('#' + myButtonID).click();
getData('');
}
})
.always(function( jsonData ) {
// Reset mode
$('#input-mode').val('');
// Reset input fields
resetModalInputFields();
})
.fail(function( xhr, ajaxOptions, thrownError ) {
console.log('I am failed..');
console.log( thrownError );
console.log( xhr );
});
}
//=============================================================================
// Delete confirm
//=============================================================================
function dataDeleteConfirm( )
{
$('#input-mode').val('*delete');
var row = thisGlobalRowData;
var input_HUB_WEBNAM = row["HUB_WEBNAM"];
$('#confirm-delete-HUB_WEBNAM').val(input_HUB_WEBNAM);
// Create confirm text
$('#confirm-delete-text-HUB_WEBNAM').html(input_HUB_WEBNAM);
$('#HUB_WEBCNT_confirmDeleteModal').modal('show');
}
//=============================================================================
// Delete
//=============================================================================
function dataDeleteExec()
{
// Reset modal message
resetModalMessage();
var mode = $('#input-mode').val();
// Make array and json
var myData = $('#dataForm-delete').find('input, select').serializeArray();
var result = JSON.stringify(myData);
// console.log(result);
// console.log(myData);
//return;
var parmData = 'data=' + result
+ '&mode=' + mode
;
$.ajax({
url: "HUB_WEBCNT_maintain_save.php",
type: "POST",
data: parmData,
dataType: "json",
cache: false,
})
.done(function( jsonData ) {
$('#HUB_WEBCNT_confirmDeleteModal').modal('hide');
//=================================================================
// Only when add
//=================================================================
if ( mode == '*delete' ) {
var myButtonID = 'select-button-line-id-' + $('#input-HUB_SERTYP').val();
$('#' + myButtonID).click();
resetModalInputFields();
getData('');
}
})
.always(function( jsonData ) {
})
.fail(function( xhr, ajaxOptions, thrownError ) {
console.log('I am failed..');
console.log( xhr );
});
}
//=============================================================================
// Check if userid exists
//=============================================================================
function checkDataExists()
{
return;
var HUB_WEBNAM = $('#modal-input-HUB_WEBNAM').val();
// If update, then the "orginal" code is ok
if ( $('#input-mode').val() == '*update' ) {
if ( HUB_WEBNAM == save_HUB_WEBNAM ) {
// return;
}
}
var parmData = 'HUB_WEBNAM=' + HUB_WEBNAM
;
$.ajax({
url: "hub_conchk_get.php",
type: "GET",
data: parmData,
dataType: "json",
cache: false,
})
.done(function( jsonData ) {
var returnCode = jsonData.header.returnCode;
var returnMsg = jsonData.header.returnMsg;
var entries_found = jsonData.header.entries_found;
var returnConfigValue = jsonData.header.returnConfigValue;
var returnConfigValueText = jsonData.header.returnConfigValueText;
if ( returnConfigValue == '50') {
$('#modal-message').addClass(' border-bottom').html( '<?php echo $datahub_error0087 ?>' );
$('#modal-save-button').addClass('disabled').prop("disabled", true);
$('#modal-input-HUB_WEBNAM').trigger('focus');
return false;
} else {
// DESCP = jsonData.detail[0].DESCP
// $('#modal-input-HUB_COUNT').val( DESCP );
}
// Reset modal message
resetModalMessage();
})
.always(function( jsonData ) {
})
.fail(function( xhr, ajaxOptions, thrownError ) {
console.log('I am failed..');
console.log( xhr );
});
}
//=============================================================================
// Show deleted
//=============================================================================
function showDeleted()
{
var show_deleted = $('#input-show-deleted').val();
if ( show_deleted == 'Y' ) {
$('#button-show-deleted').html('<?php echo $datahub_NO ?>');
$('#input-show-deleted').val('N');
} else {
$('#button-show-deleted').html('<?php echo $datahub_YES ?>');
$('#input-show-deleted').val('Y');
}
}
//=============================================================================
// Set default modal input fields
//=============================================================================
function setModalInputDefaultFields()
{
var myHUB_WEBNAM = $('#input-HUB_SERTYP').val();
// $('#modal-input-HUB_LSTCAL').val('1');
// $('#modal-input-HUB_CHRCOL').val( $('#input-current-date').val() );
// $('#modal-input-HUB_CHRTXT').val( $('#input-current-time').val() );
}
//=============================================================================
// Reset modal input fields
//=============================================================================
function resetModalInputFields()
{
// $('#modal-input-HUB_LSTCAL').val('');
// $('#modal-input-HUB_DESCP1').val('');
// $('#modal-input-HUB_WEBNAM').val('');
// $('#modal-input-HUB_SERTYP').val('');
// $('#modal-input-HUB_COUNT').val('');
// $('#modal-input-HUB_DESCP2').val('');
// $('#modal-input-HUB_CHRCOL').val('');
// $('#modal-input-HUB_CHRCOL').val('');
// $('#modal-input-HUB_CHRTXT').val('');
$('#input-mode').val('');
}
//=============================================================================
// Log off
//=============================================================================
function signoff()
{
window.location.href = "logout.php";
}
//=============================================================================
// Load page
//=============================================================================
function loadPage(url, p1, p2, p3)
{
window.location.href = url;
}
//=============================================================================
// Reset modal message
//=============================================================================
function resetModalMessage() {
// Reset
//$('#modal-message').removeClass('p-2 font-weight-bold border border-danger rounded bg-light').html( ' ' );
$('#modal-message').removeClass('border-bottom').html( ' ' );
$('#modal-save-button').removeClass('disabled').prop("disabled", false);
}
//=============================================================================
// Clean input string
//=============================================================================
function cleanInputString( myWorkField )
{
let charactersToRemove = '?#"\'';
let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');
myWorkField = myWorkField.replace(myPattern,'');
return myWorkField;
}
//=============================================================================
// Full screen popup
//=============================================================================
function popUpFull( url, p1, p2, p3 )
{
var winname = 'win_' + url;
params = 'width='+screen.width;
params += ', height='+screen.height;
params += ', top=0, left=0'
params += ', fullscreen=yes';
params += ',scrollbars=1';
overview_win = window.open(url,winname, params);
if (window.focus) {overview_win.trigger('focus')}
return false;
}
//=============================================================================
// screen popup - center
//=============================================================================
function popUpCenter(url, p1, p2, p3)
{
var v1_w = screen.availWidth;
var v1_h = screen.availHeight;
if ( parseInt(v1_w) > 1800 ) {
v1_w = 1800;
v1_h = v1_h - 200;
v1_center = v1_w/0.8;
}
// Center popup as good as possible
var left = (screen.width - v1_w) / 2;
var top = (screen.height - v1_h) / 4;
var winname = 'win_' + url;
params = 'width='+v1_w;
params += ', height='+v1_h;
params += ', top=' + top + ', left=' + left;
params += ', fullscreen=yes';
params += ',scrollbars=1';
overview_win = window.open(url,winname, params);
if (window.focus) {overview_win.trigger('focus')}
return false;
}
//=============================================================================
// screen popup - center - bigger
//=============================================================================
function popUpCenterBig(url, p1, p2, p3)
{
var v1_w = screen.availWidth;
var v1_h = screen.availHeight;
// Get 25%
v1_w_pct = v1_w * 0.25;
v1_w_new = v1_w - v1_w_pct;
if ( v1_w_new < 1 ) {
v1_w_new = 1800;
}
v1_w = v1_w_new;
v1_h = v1_h - 200;
v1_center = v1_w/0.8;
// Center popup as good as possible
var left = (screen.width - v1_w) / 2;
var top = (screen.height - v1_h) / 4;
var winname = 'win_' + url;
params = 'width='+v1_w;
params += ', height='+v1_h;
params += ', top=' + top + ', left=' + left;
params += ', fullscreen=yes';
params += ',scrollbars=1';
overview_win2 = window.open(url, winname, params);
if (overview_win2 && !overview_win2.closed) {
overview_win2.focus();
}
}
//=============================================================================
// Popup top
//=============================================================================
function popUpTop(url, p1, p2, p3)
{
var winname = 'win_' + url;
w = 650;
h = 750;
params = 'width='+w;
params += ', height='+h;
params += ', top=0, left=0'
params += ', fullscreen=no';
params += ',scrollbars=1';
overview_win = window.open(url,winname, params);
if (window.focus) {overview_win.trigger('focus')}
return false;
}
//=============================================================================
// Clean input string
//=============================================================================
function cleanInputString( myWorkField )
{
let charactersToRemove = '?#"\'';
let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');
myWorkField = myWorkField.replace(myPattern,'');
return myWorkField;
}
//=============================================================================
// Set config type
//=============================================================================
function setConfigType( inputType )
{
outputType = inputType;
if ( inputType == 'A' ) {
var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A;
}
if ( inputType == 'N' ) {
var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N;
}
if ( inputType == 'L' ) {
var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L;
}
if ( inputType == 'T' ) {
var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T;
}
return outputType;
}
//=============================================================================
// Create config type buttons
//=============================================================================
function createConfigTypeButtons()
{
}
//=============================================================================
// Select config type
//=============================================================================
function selectConfigType( inputType )
{
$('#modal-input-HUB_COUNT').val( inputType );
// Remove all "active" marks
$('.btn-config-type').removeClass('active btn-success').addClass('btn-primary');;
// Mark button as selected
myID = 'button-config_type-button-' + inputType;
$('#' + myID ).addClass('active btn-success').removeClass('btn-primary');
}
//=============================================================================
// Select line modal
//=============================================================================
function selectGroupValueModal( inputLine )
{
$('#modal-input-HUB_SERTYP').val( inputLine );
var selectButtonLineID = 'select-button-line-id-modal-' + inputLine;
$('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary');
$('#' + selectButtonLineID).removeClass('btn-primary').addClass('btn-success');
// Place cursor
$('#modal-input-HUB_WEBNAM').trigger('focus');
resetModalMessage();
}
//=============================================================================
// Reset line modal
//=============================================================================
function resetLineModal()
{
resetModalMessage()
let inputLine = $('#modal-input-HUB_WEBNAM').val();
if ( inputLine == '' ) {
$('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary');
}
}
//=============================================================================
// Set action type
//=============================================================================
function setActionType( inputType )
{
outputType = '';
if ( inputType == '*PDF' ) {
outputType = '1';
}
if ( inputType == '*PIC' ) {
outputType = '2';
}
if ( inputType == '*SCAN' ) {
outputType = '3';
}
if ( inputType == '*MOVIE' ) {
outputType = '4';
}
if ( inputType == '*LINK' ) {
outputType = '5';
}
if ( inputType == '*CHECK' ) {
outputType = '6';
}
return outputType;
}
//=============================================================================
// Open previewer
//=============================================================================
function preViewElement( myElement )
{
let h = $(window).height();
let w = $(window).width();
console.log('h: ' + h + ' -- ' + 'w: ' + w);
h = h * 0.75;
console.log('h: ' + h + ' -- ' + 'w: ' + w);
// Create ID
let myID = '#' + myElement;
let myURL = $( myID ).val();
let myIFRAME = '<iframe style="height:' + h + 'px;width:100%;" src=' + myURL +'></iframe>';
// Set iframe
$('#modal-preview-iframe').html( myIFRAME );
// Show modal
$('#HUB_WEBCNT_previewModal').modal('show');
}
//=============================================================================
// Show transcations
//=============================================================================
function showTranscations( HUB_WEBNAM )
{
var url = 'hub_webtrn_maintain.php';
var p1 = '';
var p2 = 'new-tab';
var p3 = '';
url = url + '?webnam=' + HUB_WEBNAM;
popUpCenterBig(url, p1, p2, p3);
}
//=============================================================================
// Show chart - transactions
//=============================================================================
function showChartTransactions ( HUB_WEBNAM )
{
var url = 'hub_webtrn_chart.php';
var p1 = '';
var p2 = '';
var p3 = '';
var win_type = 'new-tab';
url = url + '?hub_webnam=' + HUB_WEBNAM;
popUpCenterBig(url, p1, p2, p3);
}
//=============================================================================
// Show chart
//=============================================================================
function showChart()
{
// Get prveious search
var url = 'hub_webcnt_chart.php';
var p1 = '';
var p2 = 'new-tab';
var p3 = $('#input-prv-searchBy').val();
popUpCenterBig(url, p1, p2, p3);
}
//=============================================================================
// Get data - search
//=============================================================================
function setWebserviceSearch( input_HUB_SERTYP )
{
// Save curreent webservice name
$('#input-HUB_SERTYP').val( input_HUB_SERTYP );
var selectButtonLineID = 'select-button-line-id-' + input_HUB_SERTYP;
// Set clicked button
$('.select-button-line').removeClass('btn-success').addClass('btn-dark');
$('#' + selectButtonLineID).removeClass('btn-dark').addClass('btn-success');
// Search - destory table and start over again
//$('#REEFTvisual_data').DataTable().clear().destroy();
$('#REEFTvisual_data').DataTable().clear().draw();
//getData();
//setDataTables();
}
//=============================================================================
// Set Yes/No button
//=============================================================================
function set_YES_NO_Button( inputValue, inputID, inputType )
{
// Bool
if ( inputType == 'bool' )
{
if (inputValue == '')
{
inputValue = '0';
}
}
// Value
if ( inputType == 'value' )
{
if (inputValue == '')
{
inputValue = 'N';
}
}
var yesID = 'button-yes-' + inputID;
var noID = 'button-no-' + inputID;
var thisID = 'modal-input-' + inputID;
if ( inputType == 'bool' ) {
if ( inputValue == '1' ) {
$('#' + yesID).removeClass('btn-primary').addClass('btn-success');
$('#' + noID).removeClass('btn-success').addClass('btn-primary');
} else {
$('#' + yesID).removeClass('btn-success').addClass('btn-primary');
$('#' + noID).removeClass('btn-primary').addClass('btn-success');
}
}
if ( inputType == 'value' ) {
if ( inputValue == 'Y' ) {
$('#' + yesID).removeClass('btn-primary').addClass('btn-success');
$('#' + noID).removeClass('btn-success').addClass('btn-primary');
} else {
$('#' + yesID).removeClass('btn-success').addClass('btn-primary');
$('#' + noID).removeClass('btn-primary').addClass('btn-success');
}
}
// Set value for input field
$('#' + thisID).val(inputValue);
}
//=============================================================================
// Close modal
//=============================================================================
function closeModal() {
$('#hub_webcnt_maintainModal').modal('hide');
}
//=============================================================================
// Set clock
//=============================================================================
function updateClock() {
var currentTime = moment().format('YYYY-MM-DD HH:mm:ss');
currentTime = REEFT_format_date( currentTime, DFT_DATE_DISPLAY_FORMAT )
$('#input-current-date').val( moment().format('YYYY-MM-DD') );
$('#input-current-time').val( moment().format('HH:mm:ss') );
$('#current-time').html( currentTime );
// If add mode update date/time in modal window
if ( $('#input-mode').val() == '*add' )
{
$('#modal-input-HUB_CHRCOL').val( $('#input-current-date').val() );
$('#modal-input-HUB_CHRTXT').val( $('#input-current-time').val() );
}
}
//=============================================================================
// jQuery - Ready
//=============================================================================
$(document).ready(function()
{
// When closing modal
$('#hub_webcnt_maintainModal').on('hidden.bs.modal', function (e) {
resetModalInputFields();
})
// Do not show deleted
$('#input-show-deleted').val('Y');
$('#input-HUB_SERTYP').val('<?php echo $HUB_SERTYP ?>');
// Get data done by datatables
setDataTables();
$('#delay-marker-id').html('<i id="delay-marker-icon-id" class="text-success fa-solid fa-circle"></i>');
//-----------------------------------------------------------------------
// Start the clock
//-----------------------------------------------------------------------
updateClock();
setInterval(function() {
updateClock();
}, 1000);
//-----------------------------------------------------------------------
//-----------------------------------------------------------------------
// Set font awesome icon type
//-----------------------------------------------------------------------
// Value is from config/config.php
var iconType = '<?php echo $DFT_SET_FONT_AWESOME_ICON_TYPE ?>';
setFontAwesomeIconType( iconType );
//-----------------------------------------------------------------------
//-----------------------------------------------------------------------
// Delay keyup checker
//-----------------------------------------------------------------------
var delay = (function () {
var timer = 0;
return function (callback, ms) {
clearTimeout(timer);
timer = setTimeout(callback, ms);
};
})()
// DataTable search delay
$('#REEFTvisual_data_wrapper .dataTables_filter input')
.unbind() // overrule normal behavior
.bind('keyup', function(e){
$('#delay-marker-icon-id').removeClass('text-success').addClass('text-danger');
var inputValue = $('.dataTables_filter input').val();
var currSearchValue = $('#input-search-line').val();
if (inputValue != currSearchValue) {
$('#input-search-line').val( inputValue );
//If enter or delete we update immediately, consider to add backspace=8 and delete=46 also
const keyList = [13];
if (keyList.includes(e.keyCode)) {
// console.log('immediately ' + inputValue );
$('#delay-marker-icon-id').removeClass('text-danger').addClass('text-success');
thisGlobalTableData.search(inputValue).draw(); // fire in the hole
} else {
delay(function () {
// console.log('this will hit, once user has not typed for 1 second ' + inputValue );
$('#delay-marker-icon-id').removeClass('text-danger').addClass('text-success');
thisGlobalTableData.search(inputValue).draw(); // fire in the hole
}, 0800);
}
}
});
//=========================================================================================================
// Set color picker - TEXT
//
// Create HEX value (https://en.wikipedia.org/wiki/Web_colors)
// var hexValueColor = color.toHexString();
//
// Create RGB (https://en.wikipedia.org/wiki/RGB_color_model)
// hexcolor = hexcolor.replace("#", "");
// var r = parseInt(hexcolor.substr(0,2),16);
// var g = parseInt(hexcolor.substr(2,2),16);
// var b = parseInt(hexcolor.substr(4,2),16);
// var yiq = ((r*299)+(g*587)+(b*114))/1000;
//
//
// Create YIQ (https://en.wikipedia.org/wiki/YIQ)
// if ( yiq >= 128) {
// var textColor = 'black';
// } else {
// var textColor = 'white';
// }
//
// console.log('change: ' + hexcolor + ' ' + hexValueColor + ' ' + yiq + ' ' + r + ' ' + g + ' ' + b );
//
//=========================================================================================================
$(".text-color-palette").spectrum({
showInitial: true,
showInput: true,
chooseText: "Vælg farve",
cancelText: "Annuller",
preferredFormat: "hex",
color: "#000",
showPalette: true,
flat: false,
palette: [
["#000","#444","#666","#999","#ccc","#eee","#f3f3f3","#fff"],
["#f00","#f90","#ff0","#0f0","#0ff","#00f","#90f","#f0f"],
["#f4cccc","#fce5cd","#fff2cc","#d9ead3","#d0e0e3","#cfe2f3","#d9d2e9","#ead1dc"],
["#ea9999","#f9cb9c","#ffe599","#b6d7a8","#a2c4c9","#9fc5e8","#b4a7d6","#d5a6bd"],
["#e06666","#f6b26b","#ffd966","#93c47d","#76a5af","#6fa8dc","#8e7cc3","#c27ba0"],
["#c00","#e69138","#f1c232","#6aa84f","#45818e","#3d85c6","#674ea7","#a64d79"],
["#900","#b45f06","#bf9000","#38761d","#134f5c","#0b5394","#351c75","#741b47"],
["#600","#783f04","#7f6000","#274e13","#0c343d","#073763","#20124d","#4c1130"]
],
// Called as the original input changes. Only happens when the input is closed or the 'Choose' button is clicked.
change: function(color) {
// Get hex color
var hexValueColor = color.toHexString();
},
move: function(color) {
// Get hex color
var hexValueColor = color.toHexString();
},
show: function(color) {
$('#input-current-color-picker').val( this.id );
// Get hex color
var hexValueColor = color.toHexString();
},
hide: function(color) {
// Get hex color
var hexValueColor = color.toHexString();
}
});
//-----------------------------------------------------------------------
// Check exists
//-----------------------------------------------------------------------
let $filter01 = $('#modal-input-HUB_WEBNAM');
$filter01.on('keyup', function () {
delay(function () {
var inputValue = $('#modal-input-HUB_WEBNAM').val();
if ( inputValue != '') {
console.log('this will hit, once user has not typed for 1 second ' + inputValue );
checkDataExists();
}
}, 0800);
});
//-----------------------------------------------------------------------
// Event listener for the update button
//-----------------------------------------------------------------------
$('#updateButton').on('click', function() {
// Trigger a redraw of the table
thisGlobalTableData.draw();
});
//-----------------------------------------------------------------------
// Set short cuts
//-----------------------------------------------------------------------
// If add d-none class, do not add shortcut
if ( GLOBAL_ADD_ALLOWED == 'Y' ) {
shortcut.add("Alt+F6",function() {
$('#add-button').click();
});
// Show add button
$('#add-button').removeClass('d-none');
}
// // Close window
// shortcut.add("Shift+Esc",function() {
// $('#button-close').click();
// });
});
// -->
</script>
</head>
<body>
<div class="container-fluid mt-2 pl-3 pr-3">
<input type="text" class="d-none" id="input-HUB_SERTYP">
<input type="text" class="d-none" id="input_search">
<input type="text" class="d-none" id="input-mode">
<input type="text" class="d-none" id="input-current-date">
<input type="text" class="d-none" id="input-current-time">
<input type="text" class="d-none" id="input-show-deleted" >
<input type="text" class="d-none" id="input-search-line">
<input type="text" class="d-none" id="input-filter-line">
<input type="text" class="d-none" id="input-rpyOffSet">
<input type="text" class="d-none" id="input-rpyTotalRecordsFound">
<input type="text" class="d-none" id="input-rpyTotalPages">
<input type="text" class="d-none" id="input-rpyPageSize">
<div class="row">
<div class="col-2">
<img src="images/customer-logo.png" alt="Customer Logo">
</div>
<div class="col-8 text-center <?php echo $DFT_CLOCK_SIZE ?>">
<i class="font-awesome-pseudo-class fa-thin fa-clock"></i> <span id="current-time"><?php echo date('d-m-Y h:i:s') ?></span>
</div>
<div class="col-2 text-right">
<div class="btn btn-primary mb-1" onclick="loadPage('menu_admin.php','','','')" title="<?php echo $datahub_go_to_my_dear_home ?>"><i class="font-awesome-pseudo-class fa-2x fa-thin fa-home"></i></div>
<div class="d-none">
<div class="btn btn-primary mb-1 d-none d-xl-inline-block" onclick="loadPage('menu_main.php','','','')" title="<?php echo $datahub_go_to_my_dear_home_03 ?>"><i class="font-awesome-pseudo-class fa-2x fa-thin fa-fort"></i></div>
<div class="btn btn-danger mb-1 d-none d-lg-inline-block" onclick="signoff()" title="<?php echo $datahub_go_to_my_dear_home_02 ?>"><i class="font-awesome-pseudo-class fa-thin fa-2x fa-right-from-bracket"></i></div>
</div>
</div>
</div>
<div class="row">
<div class="col-12 text-center">
<div id="data-hub-company-information"></div>
</div>
</div>
<div class="card mt-2">
<div class="card-header text-muted">
<div class="row mt-2">
<div class="col-4 h4">
<i class="font-awesome-pseudo-class fa-thin fa-alicorn"></i> <?php echo "$datahub_text0142"; ?>
</div>
<div class="col-4 text-center">
<span title="Show as chart" onclick="showChart()" style="cursor: pointer;"><i class="fa-duotone fa-4x fa-solid fa-chart-mixed" style="--fa-primary-color: orange; --fa-secondary-color: forestgreen; --fa-secondary-opacity: 0.7;"></i></span>
<br>
<span onclick="showChart()" style="cursor: pointer;">Show chart</span>
</div>
<div class="col-4 text-right font-weight-bold">
<div class="row">
<div class="col text-right d-none">
<?php echo $datahub_text0059 ?> <span id="text-current-page">...</span> <?php echo $datahub_text0060 ?> <span id="text-total-pages">...</span>
</div>
</div>
<div class="row">
<div class="col text-right">
<?php echo $datahub_text0061 ?> : <span id="text-total-records-found">...</span>
</div>
</div>
</div>
</div>
</div>
<div class="card-body">
<!-- Message if screen is not wide enough -->
<div class="container-fluid mt-2 mb-4 d-block d-lg-none">
<div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div>
</div>
<!-- Message if screen is not wide enough -->
<!-- Group lines found -->
<div class="d-none d-lg-block">
<div class="row mb-2">
<div class="col-12">
<div id="data-result-button-group"></div>
</div>
</div>
</div>
<div class="row mt-2">
<div class="col-12">
<table id="REEFTvisual_data" class="table table-bordered table-striped table-hover">
<thead>
<tr class="bg-primary text-white font-weight-bold text-center">
<th class="text-left"><?php echo $datahub_text0140 ?></th>
<th class="text-left"><?php echo "$datahub_text0149 ($datahub_text0145)" ?></th>
<th class="text-left"><?php echo $datahub_text0146 ?> 1</th>
<th class="text-left"><?php echo $datahub_text0147 ?></th>
<th class="text-left"><?php echo $datahub_text0148 ?></th>
<th class="text-left"><?php echo $datahub_text0216 ?></th>
<th class="text-left"><?php echo $datahub_text0217 ?></th>
<th class="text-left"><?php echo $datahub_text0219a?></th>
<th class="text-left"><?php echo $datahub_text0220a?></th>
<th class="text-left"><?php echo $datahub_text0225a?></th>
<th class="text-left"><button type="button" id="add-button" title="Shortcut: Alt+F6" onclick="dataAdd('0')" class="d-none btn btn-dark btn-block font-weight-bold"><?php echo $datahub_button_save_01 ?></button></th>
<th class="text-left"></th>
<th class="text-left"></th>
<th class="text-left"></th>
<th class="text-left">HUB_DBGVAL</th>
<th class="text-left">HUB_DESCP1</th>
<th class="text-left">HUB_DESCP2</th>
<th class="text-left">HUB_CHRCOL</th>
<th class="text-left">HUB_SHWCHT</th>
</tr>
</thead>
</table>
</div>
</div>
<div class="row">
<div class="col text-right mb-2">
<small><div id="load-time-from-database"></div></small>
</div>
</div>
</div>
</div>
</div>
<!-- Set footer -->
<?php
include "include/footer.php";
?>
<!-- Set footer -->
<!-- ========================================================================== -->
<!-- M O D A L S -->
<!-- ========================================================================== -->
<!-- Modal -->
<div class="modal fade" id="hub_webcnt_maintainModal" tabindex="-1" data-backdrop="static" role="dialog" aria-labelledby="hub_webcnt_maintainModalLabel" aria-hidden="true">
<div class="modal-dialog modal-xxl">
<div class="modal-content">
<div class="modal-header bg-primary text-white">
<div class="container-fluid pl-0 pr-0">
<div class="row">
<div class="col-8">
<h5 class="modal-title" id="hub_webcnt_maintainModalLabel"><i class="font-awesome-pseudo-class fa-thin fa-alicorn"></i> <?php echo $datahub_text0142 ?></h5>
</div>
<div class="col text-right">
</div>
<div class="col-1 text-right" style="max-width:20px">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
</div>
</div>
</div>
<div class="modal-body ml-2 mr-2">
<input type="text" class="d-none" id="input-current-color-picker">
<input type="text" class="d-none" id="input-current-text-color">
<input type="text" class="d-none" id="input-current-background-color">
<!-- Message if screen is not wide enough -->
<div class="container-fluid mt-2 mb-4 d-block d-lg-none">
<div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div>
</div>
<!-- Message if screen is not wide enough -->
<form name="dataForm" id="dataForm">
<!-- Hidden fields start -->
<!-- Hidden fields end -->
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0140 ?>
</div>
<div class="col-3">
<input class="form-control read-only-class" type="text" id="modal-input-HUB_WEBNAM" maxlength="50" name="modal-input-HUB_WEBNAM">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0149 ?>
</div>
<div class="col-3">
<input class="form-control read-only-class" type="text" id="modal-input-HUB_LSTCAL" name="modal-input-HUB_LSTCAL">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0147 ?>
</div>
<div class="col-2">
<input class="form-control read-only-class" type="text" id="modal-input-HUB_COUNT" name="modal-input-HUB_COUNT">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0146 ?> 1
</div>
<div class="col-6">
<textarea class="form-control" id="modal-input-HUB_DESCP1" name="modal-input-HUB_DESCP1" rows="2" onkeyup="resetModalMessage()"></textarea>
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0146 ?> 2
</div>
<div class="col-6">
<textarea class="form-control" id="modal-input-HUB_DESCP2" name="modal-input-HUB_DESCP2" rows="2" onkeyup="resetModalMessage()"></textarea>
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0148 ?>
</div>
<div class="col-2">
<input class="form-control" type="text" id="modal-input-HUB_SERTYP" name="modal-input-HUB_SERTYP">
</div>
<div class="col-6">
<div id="data-result-button-group-modal"></div>
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0216 ?>
</div>
<div class="col-2">
<input class="text-color-palette form-control" type="text" id="modal-input-HUB_CHRCOL" name="modal-input-HUB_CHRCOL">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0217 ?>
</div>
<div class="col-2">
<input class="form-control" type="text" id="modal-input-HUB_CHRTXT" name="modal-input-HUB_CHRTXT">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0219 ?>
</div>
<div class="col-2">
<input class="form-control" type="text" id="modal-input-HUB_CHRMIN" name="modal-input-HUB_CHRMIN">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0220 ?>
</div>
<div class="col-2">
<input class="form-control" type="text" id="modal-input-HUB_CHRMAX" name="modal-input-HUB_CHRMAX">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0224 ?>
</div>
<div class="col-2">
<input class="form-control" type="text" id="modal-input-HUB_DBGVAL" name="modal-input-HUB_DBGVAL">
</div>
</div>
<div class="row mt-2">
<div class="col-3">
<?php echo $datahub_text0225 ?>
</div>
<div class="col-2">
<button type="button" onclick="set_YES_NO_Button('Y','HUB_SHWCHT','value')" class="btn btn-primary" id="button-yes-HUB_SHWCHT"><?php echo $datahub_YES ?></button>
<button type="button" onclick="set_YES_NO_Button('N','HUB_SHWCHT','value')" class="btn btn-primary" id="button-no-HUB_SHWCHT"><?php echo $datahub_NO ?></button>
<input class="form-control d-none" type="text" id="modal-input-HUB_SHWCHT" name="modal-input-HUB_SHWCHT">
</div>
</div>
</form>
</div>
<div class="modal-footer-pretty modal-footer">
<div class="container-fluid">
<div class="row">
<div class="col-12 text-left">
<div class="p-1 font-weight-bold text-danger border-top border-dark " id="modal-message"> </div>
</div>
</div>
<div class="row mt-1 mb-2">
<div class="col-3 text-left">
<button type="button" id="modal-save-button" class="btn btn-primary btn-block" onclick="dataSave()"><?php echo $datahub_button_save ?></button>
</div>
<div class="col-6 text-right">
</div>
<div class="col-3 text-right">
<button type="button" class="btn btn-primary btn-block" data-dismiss="modal"><?php echo $datahub_button_cancel_01 ?></button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- ************************************************ -->
<!-- Confirm delete -->
<!-- ************************************************ -->
<div class="modal fade" id="HUB_WEBCNT_confirmDeleteModal" tabindex="-1" role="dialog" aria-labelledby="HUB_WEBCNT_confirmDeleteModalLabel" aria-hidden="true">
<div class="modal-dialog modal-xl" role="document">
<div class="modal-content">
<div class="modal-header bg-primary text-white">
<h5 class="modal-title" id="HUB_WEBCNT_confirmDeleteModalLabel"><?php echo $datahub_text0063 ?></h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form name="dataForm-delete" id="dataForm-delete">
<input type="text" class="d-none" id="confirm-delete-HUB_WEBNAM" name="confirm-delete-HUB_WEBNAM">
</form>
<div class="h6"><?php echo $datahub_text0062 ?>: <span class="font-weight-bold" id="confirm-delete-text-HUB_WEBNAM"></span></div>
</div>
<div class="modal-footer">
<div class="container-fluid">
<div class="row mt-1 mb-2">
<div class="col-3 text-left">
<button type="button" onclick="dataDeleteExec()" class="btn btn-primary"><?php echo $datahub_button_delete ?></button>
</div>
<div class="col-6 text-right">
</div>
<div class="col-3 text-right">
<button type="button" class="btn btn-primary" data-dismiss="modal"><?php echo $datahub_button_cancel ?></button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>